﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace MixScript.BLL.FI
{
    public class requestRemitances : cBaseBLL
    {
        public requestRemitances() { }

        public DataTable requestRemitance(String month, String year)
        {
            String sSql = @"SELECT *, CAST(req_date aS NVARCHAR(12)) AS tanggal, 
                            CAST(actual_date as NVARCHAR(12)) AS act_tgl, 
                            CAST(rcv_date as NVARCHAR(12)) AS rcv_tgl FROM acc_remitdet1 
                            WHERE MONTH(req_date) = '{0}' AND  YEAR(req_date) = '{1}'
                            ORDER BY rr_id";
            return Dbserver.ExecuteQuery(String.Format(sSql, month, year), "account");

        }


    }
}
